Distributed Warehouses: A Review on Design Methods and Recent Trends

The distributed data warehouse supports the decision makers by providing a single view of data even though that data is physically distributed across multiple data warehouses in multiple systems at different branches. This environment has changed the face of computing and offered quick and precise solutions for a variety of complex problems for different fields. This paper reviews distributed data warehouse systems in view of its appearance compared to centralized data warehouses, frame work for distributed warehouse systems, data base designs and a good discussion on recent developments in distributed data warehouse architectures. It also concentrates the latest systems and various optimization methods.